{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Card List","Individual Order Form","Monthly Sales","Monthly Orders","Monthly Inventory","Formulas","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":100,"n_cols":4,"rows_kept":100,"cut":false,"hidden":false,"merged":[[24,3,24,16],[25,3,25,17],[26,3,26,17],[0,0,0,8],[18,3,18,16],[21,3,21,17],[22,3,22,17],[19,3,19,17],[20,3,20,17]]}
["File Instructions"]
["GENERAL:"]
["1)","Use a new File for each month.  Keep the \"Blank\" file so you can copy and use each month."]
[]
["2)","Save files by month and year date.  For example:  Scrip_March2023"]
[]
[]
[null,"Monthly Sales:",null,"This form is to record each week of sales for the month."]
[null,null,null,"It must tie to the deposit (see form)."]
[null,null,null,"In addition, the form tracks all IOUs and the IOU balances."]
[]
[null,"Monthly Orders:",null,"This sheet is to track the monthly cards ordered and costs."]
[null,null,null,"Each order should tie to the order form from the scrip company."]
[]
[null,"Monthly Inventory:",null,"This sheet is to tracks the iventory of cards on hand."]
[]
["INSTRUCTIONS FOR EACH FORM:"]
[]
["Individual Order Form:"]
[null,null,"*","This form can be printed for the customers to use for their orders."]
[null,null,"*","Please be sure to total the order (at bottom right) as well as to note the amount paid for the order.  We need to track IOUs so this information is very important."]
[null,null,"*","If a change is needed to any information in blue, you can do this and all the links/formulas on the other tabs will change as well.  To change the X or check mark (use 0 for X and 1 for check mark in the cell)."]
[null,null,"*","If you need to add a new vendor or delete an existing vendor you must take care to change all the tabs and insure all the links/formulas are correct or make a list of what needs to be added or deleted and Dawn will do this for you :)"]
[]
["Monthly Sales"]
[null,null,"*","This form is to track all the monthly sales for the month."]
[null,null,"*","The intent is that for each deposit for the month, the total of orders less any IOUs must tie to the total of each deposit."]
[null,null,"*","Steps:"]
[null,null,null,"1)  Enter month and year at top of page."]
[null,null,null,"2)  Each deposit should be entered in a separate column (5 total columns available) so that we can total the month."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["LCRDawn"]

{"sheet":"Card List","index":1,"n_rows":95,"n_cols":4,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[null,"Retailer","Card Amt.","Profit %"]
[1,"Amazon",25,2.2499999999999999E-2]
[]
[0,"American Eagle",25,0.1]
[0,"Apple iTunes",15,0.05]
[0,"Applebee's",25,0.08]
[1,"Arby's",10,0.08]
[1,"Barnes & Noble",10,0.08]
[1,"Bath & Body Works",10,0.13]
[0,"Bed Bath & Beyond",25,7.0000000000000007E-2]
[0,"Best Buy",25,0.04]
[1,"BP Oil/Amoco",50,1.4999999999999999E-2]
[0,"Buffalo Wild Wings",25,0.08]
[0,"Burger King",10,0.04]
[0,"Cheddars",25,0.08]
[0,"Cheesecake Factory",25,0.05]
[0,"Chili's/Maggiano's",25,0.11]
[1,"Chipotle",10,0.1]
[1,"Cousin's",10,0.09]
[1,"Cracker Barrel",25,0.08]
[0,"Dairy Queen",10,0.03]
[0,"Denny's",10,7.0000000000000007E-2]
[0,"Disney",25,0.03]
[0,"Domino's",25,0.08]
[1,"Dunkin' ",10,0.03]
[1,"Exxon/Mobil",50,1.4999999999999999E-2]
[1,"Festival Foods",25,0.03]
[1,"Festival Foods",50,0.03]
[0,"Finish Line",25,0.1]
[0,"GameStop",25,0.03]
[0,"Gap",25,0.14000000000000001]
[0,"Gordon Food Service",25,0.04]
[0,"Groupon",25,7.0000000000000007E-2]
[0,"Hardee's",10,0.05]
[1,"Home Depot",25,0.04]
[0,"Jo-Ann Fabric",25,0.06]
[0,"Journeys",25,0.1]
[0,"Instacart",25,0.05]
[1,"Kohl's",25,0.04]
[1,"Kohl's",100,0.04]
[1,"Kwik Trip",25,0.04]
[1,"Kwik Trip",50,0.04]
[1,"Kwik Trip",100,0.04]
[0,"Lowe's",25,0.04]
[1,"Marcus Theatres",25,0.09]
[1,"Marshalls/TJ Maxx",25,7.0000000000000007E-2]
[0,"Maurices",20,7.0000000000000007E-2]
[1,"McDonald's",10,0.02]
[1,"McDonald's",25,0.02]
[0,"Meijer",25,0.03]
[0,"Meijer",50,0.03]
[1,"Menards",25,0.03]
[0,"Michael's",25,0.04]
[1,"Noodles & Co",10,0.08]
[0,"Old Navy",25,0.14000000000000001]
[1,"Olive Garden",25,0.08]
[1,"Panda Express",25,0.08]
[1,"Panera Bread",10,0.08]
[1,"Panera Bread",25,0.08]
[0,"Papa John's",10,0.08]
[0,"Papa Murphy's",10,0.08]
[1,"Piggly Wiggly",25,0.03]
[1,"Piggly Wiggly",50,0.03]
[1,"Piggly Wiggly",100,0.03]
[0,"Pizza Hut",10,0.08]
[0,"Potbelly",10,0.08]
[0,"Qdoba",25,7.0000000000000007E-2]
[0,"Red Lobster",25,0.08]
[0,"Red Robin",25,0.08]
[1,"Roundy's",25,0.04]
[1,"Roundy's",50,0.04]
[1,"Roundy's",100,0.04]
[0,"Shell ",25,1.4999999999999999E-2]
[1,"Speedway",25,0.04]
[1,"Speedway",50,0.04]
[1,"Speedway",100,0.04]
[1,"Starbucks",10,7.0000000000000007E-2]
[1,"Starbucks",25,7.0000000000000007E-2]
[1,"Subway",10,0.06]
[1,"Taco Bell",10,0.05]
[1,"Target",25,2.5000000000000001E-2]
[0,"Texas Roadhouse",25,0.08]
[1,"TJ Maxx/Home Goods",25,7.0000000000000007E-2]
[1,"Ulta",25,0.04]
[0,"Walgreens",25,0.05]
[1,"Walgreens",100,0.05]
[1,"Walmart",25,2.5000000000000001E-2]
[1,"Walmart",100,2.5000000000000001E-2]
[0,"Wendy's",10,0.04]
[]
[]
[]
[]
[0,"Need to Order"]
[1,"In Stock (on hand)"]

{"sheet":"Individual Order Form","index":2,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[53,6,54,9],[53,10,54,11],[42,6,42,7],[55,6,56,9],[55,10,56,11]]}
[null,"Retailer","Card Amt.","Profit %","Quantity","Cost",null,"Retailer","Card Amt.","Profit %","Quanity","Cost"]
[{"$f":"IF(+'Card List'!$A2=\"\",\"\",+'Card List'!$A2)","v":1},{"$f":"+'Card List'!$B2","v":"Amazon"},{"$f":"+'Card List'!$C2","v":25},{"$f":"'Card List'!$D2","v":2.2499999999999999E-2},null,null,{"$f":"+'Card List'!$A55","v":0},{"$f":"+'Card List'!$B55","v":"Old Navy"},{"$f":"+'Card List'!$C55","v":25},{"$f":"+IF(RIGHT('Card List'!$D55,2)=0,LEFT('Card List'!$D55,2),'Card List'!$D55)","v":0.14000000000000001},null,null,null,{"$f":"+IF(RIGHT('Card List'!D2,2)=0,LEFT('Card List'!D2,2),'Card List'!D2)","v":2.2499999999999999E-2}]
[{"$f":"IF(+'Card List'!$A3=\"\",\"\",+'Card List'!$A3)","v":""},{"$f":"+'Card List'!$B3","v":0},{"$f":"+'Card List'!$C3","v":0},{"$f":"'Card List'!$D3","v":0},null,null,{"$f":"+'Card List'!$A56","v":1},{"$f":"+'Card List'!$B56","v":"Olive Garden"},{"$f":"+'Card List'!$C56","v":25},{"$f":"+IF(RIGHT('Card List'!$D56,2)=0,LEFT('Card List'!$D56,2),'Card List'!$D56)","v":0.08},null,null,null,{"$f":"+IF(RIGHT('Card List'!D4,2)=0,LEFT('Card List'!D4,2),'Card List'!D4)","v":0.1}]
[{"$f":"IF(+'Card List'!$A4=\"\",\"\",+'Card List'!$A4)","v":0},{"$f":"+'Card List'!$B4","v":"American Eagle"},{"$f":"+'Card List'!$C4","v":25},{"$f":"'Card List'!$D4","v":0.1},null,null,{"$f":"+'Card List'!$A57","v":1},{"$f":"+'Card List'!$B57","v":"Panda Express"},{"$f":"+'Card List'!$C57","v":25},{"$f":"+IF(RIGHT('Card List'!$D57,2)=0,LEFT('Card List'!$D57,2),'Card List'!$D57)","v":0.08}]
[{"$f":"IF(+'Card List'!$A5=\"\",\"\",+'Card List'!$A5)","v":0},{"$f":"+'Card List'!$B5","v":"Apple iTunes"},{"$f":"+'Card List'!$C5","v":15},{"$f":"'Card List'!$D5","v":0.05},null,null,{"$f":"+'Card List'!$A58","v":1},{"$f":"+'Card List'!$B58","v":"Panera Bread"},{"$f":"+'Card List'!$C58","v":10},{"$f":"+IF(RIGHT('Card List'!$D58,2)=0,LEFT('Card List'!$D58,2),'Card List'!$D58)","v":0.08}]
[{"$f":"IF(+'Card List'!$A6=\"\",\"\",+'Card List'!$A6)","v":0},{"$f":"+'Card List'!$B6","v":"Applebee's"},{"$f":"+'Card List'!$C6","v":25},{"$f":"'Card List'!$D6","v":0.08},null,null,{"$f":"+'Card List'!$A59","v":1},{"$f":"+'Card List'!$B59","v":"Panera Bread"},{"$f":"+'Card List'!$C59","v":25},{"$f":"+IF(RIGHT('Card List'!$D59,2)=0,LEFT('Card List'!$D59,2),'Card List'!$D59)","v":0.08},null,null,null,{"$f":"IF(N2=0.0225,P2,CELL(\"format\",N2)=p0)","v":0}]
[{"$f":"IF(+'Card List'!$A7=\"\",\"\",+'Card List'!$A7)","v":1},{"$f":"+'Card List'!$B7","v":"Arby's"},{"$f":"+'Card List'!$C7","v":10},{"$f":"'Card List'!$D7","v":0.08},null,null,{"$f":"+'Card List'!$A60","v":0},{"$f":"+'Card List'!$B60","v":"Papa John's"},{"$f":"+'Card List'!$C60","v":10},{"$f":"+IF(RIGHT('Card List'!$D60,2)=0,LEFT('Card List'!$D60,2),'Card List'!$D60)","v":0.08}]
[{"$f":"IF(+'Card List'!$A8=\"\",\"\",+'Card List'!$A8)","v":1},{"$f":"+'Card List'!$B8","v":"Barnes & Noble"},{"$f":"+'Card List'!$C8","v":10},{"$f":"'Card List'!$D8","v":0.08},null,null,{"$f":"+'Card List'!$A61","v":0},{"$f":"+'Card List'!$B61","v":"Papa Murphy's"},{"$f":"+'Card List'!$C61","v":10},{"$f":"+IF(RIGHT('Card List'!$D61,2)=0,LEFT('Card List'!$D61,2),'Card List'!$D61)","v":0.08}]
[{"$f":"IF(+'Card List'!$A9=\"\",\"\",+'Card List'!$A9)","v":1},{"$f":"+'Card List'!$B9","v":"Bath & Body Works"},{"$f":"+'Card List'!$C9","v":10},{"$f":"'Card List'!$D9","v":0.13},null,null,{"$f":"+'Card List'!$A62","v":1},{"$f":"+'Card List'!$B62","v":"Piggly Wiggly"},{"$f":"+'Card List'!$C62","v":25},{"$f":"+IF(RIGHT('Card List'!$D62,2)=0,LEFT('Card List'!$D62,2),'Card List'!$D62)","v":0.03}]
[{"$f":"IF(+'Card List'!$A10=\"\",\"\",+'Card List'!$A10)","v":0},{"$f":"+'Card List'!$B10","v":"Bed Bath & Beyond"},{"$f":"+'Card List'!$C10","v":25},{"$f":"'Card List'!$D10","v":7.0000000000000007E-2},null,null,{"$f":"+'Card List'!$A63","v":1},{"$f":"+'Card List'!$B63","v":"Piggly Wiggly"},{"$f":"+'Card List'!$C63","v":50},{"$f":"+IF(RIGHT('Card List'!$D63,2)=0,LEFT('Card List'!$D63,2),'Card List'!$D63)","v":0.03}]
[{"$f":"IF(+'Card List'!$A11=\"\",\"\",+'Card List'!$A11)","v":0},{"$f":"+'Card List'!$B11","v":"Best Buy"},{"$f":"+'Card List'!$C11","v":25},{"$f":"'Card List'!$D11","v":0.04},null,null,{"$f":"+'Card List'!$A64","v":1},{"$f":"+'Card List'!$B64","v":"Piggly Wiggly"},{"$f":"+'Card List'!$C64","v":100},{"$f":"+IF(RIGHT('Card List'!$D64,2)=0,LEFT('Card List'!$D64,2),'Card List'!$D64)","v":0.03}]
[{"$f":"IF(+'Card List'!$A12=\"\",\"\",+'Card List'!$A12)","v":1},{"$f":"+'Card List'!$B12","v":"BP Oil/Amoco"},{"$f":"+'Card List'!$C12","v":50},{"$f":"'Card List'!$D12","v":1.4999999999999999E-2},null,null,{"$f":"+'Card List'!$A65","v":0},{"$f":"+'Card List'!$B65","v":"Pizza Hut"},{"$f":"+'Card List'!$C65","v":10},{"$f":"+IF(RIGHT('Card List'!$D65,2)=0,LEFT('Card List'!$D65,2),'Card List'!$D65)","v":0.08}]
[{"$f":"IF(+'Card List'!$A13=\"\",\"\",+'Card List'!$A13)","v":0},{"$f":"+'Card List'!$B13","v":"Buffalo Wild Wings"},{"$f":"+'Card List'!$C13","v":25},{"$f":"'Card List'!$D13","v":0.08},null,null,{"$f":"+'Card List'!$A66","v":0},{"$f":"+'Card List'!$B66","v":"Potbelly"},{"$f":"+'Card List'!$C66","v":10},{"$f":"+IF(RIGHT('Card List'!$D66,2)=0,LEFT('Card List'!$D66,2),'Card List'!$D66)","v":0.08}]
[{"$f":"IF(+'Card List'!$A14=\"\",\"\",+'Card List'!$A14)","v":0},{"$f":"+'Card List'!$B14","v":"Burger King"},{"$f":"+'Card List'!$C14","v":10},{"$f":"'Card List'!$D14","v":0.04},null,null,{"$f":"+'Card List'!$A67","v":0},{"$f":"+'Card List'!$B67","v":"Qdoba"},{"$f":"+'Card List'!$C67","v":25},{"$f":"+IF(RIGHT('Card List'!$D67,2)=0,LEFT('Card List'!$D67,2),'Card List'!$D67)","v":7.0000000000000007E-2}]
[{"$f":"IF(+'Card List'!$A15=\"\",\"\",+'Card List'!$A15)","v":0},{"$f":"+'Card List'!$B15","v":"Cheddars"},{"$f":"+'Card List'!$C15","v":25},{"$f":"'Card List'!$D15","v":0.08},null,null,{"$f":"+'Card List'!$A68","v":0},{"$f":"+'Card List'!$B68","v":"Red Lobster"},{"$f":"+'Card List'!$C68","v":25},{"$f":"+IF(RIGHT('Card List'!$D68,2)=0,LEFT('Card List'!$D68,2),'Card List'!$D68)","v":0.08}]
[{"$f":"IF(+'Card List'!$A16=\"\",\"\",+'Card List'!$A16)","v":0},{"$f":"+'Card List'!$B16","v":"Cheesecake Factory"},{"$f":"+'Card List'!$C16","v":25},{"$f":"'Card List'!$D16","v":0.05},null,null,{"$f":"+'Card List'!$A69","v":0},{"$f":"+'Card List'!$B69","v":"Red Robin"},{"$f":"+'Card List'!$C69","v":25},{"$f":"+IF(RIGHT('Card List'!$D69,2)=0,LEFT('Card List'!$D69,2),'Card List'!$D69)","v":0.08}]
[{"$f":"IF(+'Card List'!$A17=\"\",\"\",+'Card List'!$A17)","v":0},{"$f":"+'Card List'!$B17","v":"Chili's/Maggiano's"},{"$f":"+'Card List'!$C17","v":25},{"$f":"'Card List'!$D17","v":0.11},null,null,{"$f":"+'Card List'!$A70","v":1},{"$f":"+'Card List'!$B70","v":"Roundy's"},{"$f":"+'Card List'!$C70","v":25},{"$f":"+IF(RIGHT('Card List'!$D70,2)=0,LEFT('Card List'!$D70,2),'Card List'!$D70)","v":0.04}]
[{"$f":"IF(+'Card List'!$A18=\"\",\"\",+'Card List'!$A18)","v":1},{"$f":"+'Card List'!$B18","v":"Chipotle"},{"$f":"+'Card List'!$C18","v":10},{"$f":"'Card List'!$D18","v":0.1},null,null,{"$f":"+'Card List'!$A71","v":1},{"$f":"+'Card List'!$B71","v":"Roundy's"},{"$f":"+'Card List'!$C71","v":50},{"$f":"+IF(RIGHT('Card List'!$D71,2)=0,LEFT('Card List'!$D71,2),'Card List'!$D71)","v":0.04}]
[{"$f":"IF(+'Card List'!$A19=\"\",\"\",+'Card List'!$A19)","v":1},{"$f":"+'Card List'!$B19","v":"Cousin's"},{"$f":"+'Card List'!$C19","v":10},{"$f":"'Card List'!$D19","v":0.09},null,null,{"$f":"+'Card List'!$A72","v":1},{"$f":"+'Card List'!$B72","v":"Roundy's"},{"$f":"+'Card List'!$C72","v":100},{"$f":"+IF(RIGHT('Card List'!$D72,2)=0,LEFT('Card List'!$D72,2),'Card List'!$D72)","v":0.04}]
[{"$f":"IF(+'Card List'!$A20=\"\",\"\",+'Card List'!$A20)","v":1},{"$f":"+'Card List'!$B20","v":"Cracker Barrel"},{"$f":"+'Card List'!$C20","v":25},{"$f":"'Card List'!$D20","v":0.08},null,null,{"$f":"+'Card List'!$A73","v":0},{"$f":"+'Card List'!$B73","v":"Shell "},{"$f":"+'Card List'!$C73","v":25},{"$f":"+IF(RIGHT('Card List'!$D73,2)=0,LEFT('Card List'!$D73,2),'Card List'!$D73)","v":1.4999999999999999E-2}]
[{"$f":"IF(+'Card List'!$A21=\"\",\"\",+'Card List'!$A21)","v":0},{"$f":"+'Card List'!$B21","v":"Dairy Queen"},{"$f":"+'Card List'!$C21","v":10},{"$f":"'Card List'!$D21","v":0.03},null,null,{"$f":"+'Card List'!$A74","v":1},{"$f":"+'Card List'!$B74","v":"Speedway"},{"$f":"+'Card List'!$C74","v":25},{"$f":"+IF(RIGHT('Card List'!$D74,2)=0,LEFT('Card List'!$D74,2),'Card List'!$D74)","v":0.04}]
[{"$f":"IF(+'Card List'!$A22=\"\",\"\",+'Card List'!$A22)","v":0},{"$f":"+'Card List'!$B22","v":"Denny's"},{"$f":"+'Card List'!$C22","v":10},{"$f":"'Card List'!$D22","v":7.0000000000000007E-2},null,null,{"$f":"+'Card List'!$A75","v":1},{"$f":"+'Card List'!$B75","v":"Speedway"},{"$f":"+'Card List'!$C75","v":50},{"$f":"+IF(RIGHT('Card List'!$D75,2)=0,LEFT('Card List'!$D75,2),'Card List'!$D75)","v":0.04}]
[{"$f":"IF(+'Card List'!$A23=\"\",\"\",+'Card List'!$A23)","v":0},{"$f":"+'Card List'!$B23","v":"Disney"},{"$f":"+'Card List'!$C23","v":25},{"$f":"'Card List'!$D23","v":0.03},null,null,{"$f":"+'Card List'!$A76","v":1},{"$f":"+'Card List'!$B76","v":"Speedway"},{"$f":"+'Card List'!$C76","v":100},{"$f":"+IF(RIGHT('Card List'!$D76,2)=0,LEFT('Card List'!$D76,2),'Card List'!$D76)","v":0.04}]
[{"$f":"IF(+'Card List'!$A24=\"\",\"\",+'Card List'!$A24)","v":0},{"$f":"+'Card List'!$B24","v":"Domino's"},{"$f":"+'Card List'!$C24","v":25},{"$f":"'Card List'!$D24","v":0.08},null,null,{"$f":"+'Card List'!$A77","v":1},{"$f":"+'Card List'!$B77","v":"Starbucks"},{"$f":"+'Card List'!$C77","v":10},{"$f":"+IF(RIGHT('Card List'!$D77,2)=0,LEFT('Card List'!$D77,2),'Card List'!$D77)","v":7.0000000000000007E-2}]
[{"$f":"IF(+'Card List'!$A25=\"\",\"\",+'Card List'!$A25)","v":1},{"$f":"+'Card List'!$B25","v":"Dunkin' "},{"$f":"+'Card List'!$C25","v":10},{"$f":"'Card List'!$D25","v":0.03},null,null,{"$f":"+'Card List'!$A78","v":1},{"$f":"+'Card List'!$B78","v":"Starbucks"},{"$f":"+'Card List'!$C78","v":25},{"$f":"+IF(RIGHT('Card List'!$D78,2)=0,LEFT('Card List'!$D78,2),'Card List'!$D78)","v":7.0000000000000007E-2}]
[{"$f":"IF(+'Card List'!$A26=\"\",\"\",+'Card List'!$A26)","v":1},{"$f":"+'Card List'!$B26","v":"Exxon/Mobil"},{"$f":"+'Card List'!$C26","v":50},{"$f":"'Card List'!$D26","v":1.4999999999999999E-2},null,null,{"$f":"+'Card List'!$A79","v":1},{"$f":"+'Card List'!$B79","v":"Subway"},{"$f":"+'Card List'!$C79","v":10},{"$f":"+IF(RIGHT('Card List'!$D79,2)=0,LEFT('Card List'!$D79,2),'Card List'!$D79)","v":0.06}]
[{"$f":"IF(+'Card List'!$A27=\"\",\"\",+'Card List'!$A27)","v":1},{"$f":"+'Card List'!$B27","v":"Festival Foods"},{"$f":"+'Card List'!$C27","v":25},{"$f":"'Card List'!$D27","v":0.03},null,null,{"$f":"+'Card List'!$A80","v":1},{"$f":"+'Card List'!$B80","v":"Taco Bell"},{"$f":"+'Card List'!$C80","v":10},{"$f":"+IF(RIGHT('Card List'!$D80,2)=0,LEFT('Card List'!$D80,2),'Card List'!$D80)","v":0.05}]
[{"$f":"IF(+'Card List'!$A28=\"\",\"\",+'Card List'!$A28)","v":1},{"$f":"+'Card List'!$B28","v":"Festival Foods"},{"$f":"+'Card List'!$C28","v":50},{"$f":"'Card List'!$D28","v":0.03},null,null,{"$f":"+'Card List'!$A81","v":1},{"$f":"+'Card List'!$B81","v":"Target"},{"$f":"+'Card List'!$C81","v":25},{"$f":"+IF(RIGHT('Card List'!$D81,2)=0,LEFT('Card List'!$D81,2),'Card List'!$D81)","v":2.5000000000000001E-2}]
[{"$f":"IF(+'Card List'!$A29=\"\",\"\",+'Card List'!$A29)","v":0},{"$f":"+'Card List'!$B29","v":"Finish Line"},{"$f":"+'Card List'!$C29","v":25},{"$f":"'Card List'!$D29","v":0.1},null,null,{"$f":"+'Card List'!$A82","v":0},{"$f":"+'Card List'!$B82","v":"Texas Roadhouse"},{"$f":"+'Card List'!$C82","v":25},{"$f":"+IF(RIGHT('Card List'!$D82,2)=0,LEFT('Card List'!$D82,2),'Card List'!$D82)","v":0.08}]
[{"$f":"IF(+'Card List'!$A30=\"\",\"\",+'Card List'!$A30)","v":0},{"$f":"+'Card List'!$B30","v":"GameStop"},{"$f":"+'Card List'!$C30","v":25},{"$f":"'Card List'!$D30","v":0.03},null,null,{"$f":"+'Card List'!$A83","v":1},{"$f":"+'Card List'!$B83","v":"TJ Maxx/Home Goods"},{"$f":"+'Card List'!$C83","v":25},{"$f":"+IF(RIGHT('Card List'!$D83,2)=0,LEFT('Card List'!$D83,2),'Card List'!$D83)","v":7.0000000000000007E-2}]
[{"$f":"IF(+'Card List'!$A31=\"\",\"\",+'Card List'!$A31)","v":0},{"$f":"+'Card List'!$B31","v":"Gap"},{"$f":"+'Card List'!$C31","v":25},{"$f":"'Card List'!$D31","v":0.14000000000000001},null,null,{"$f":"+'Card List'!$A84","v":1},{"$f":"+'Card List'!$B84","v":"Ulta"},{"$f":"+'Card List'!$C84","v":25},{"$f":"+IF(RIGHT('Card List'!$D84,2)=0,LEFT('Card List'!$D84,2),'Card List'!$D84)","v":0.04}]
[{"$f":"IF(+'Card List'!$A32=\"\",\"\",+'Card List'!$A32)","v":0},{"$f":"+'Card List'!$B32","v":"Gordon Food Service"},{"$f":"+'Card List'!$C32","v":25},{"$f":"'Card List'!$D32","v":0.04},null,null,{"$f":"+'Card List'!$A85","v":0},{"$f":"+'Card List'!$B85","v":"Walgreens"},{"$f":"+'Card List'!$C85","v":25},{"$f":"+IF(RIGHT('Card List'!$D85,2)=0,LEFT('Card List'!$D85,2),'Card List'!$D85)","v":0.05}]
[{"$f":"IF(+'Card List'!$A33=\"\",\"\",+'Card List'!$A33)","v":0},{"$f":"+'Card List'!$B33","v":"Groupon"},{"$f":"+'Card List'!$C33","v":25},{"$f":"'Card List'!$D33","v":7.0000000000000007E-2},null,null,{"$f":"+'Card List'!$A86","v":1},{"$f":"+'Card List'!$B86","v":"Walgreens"},{"$f":"+'Card List'!$C86","v":100},{"$f":"+IF(RIGHT('Card List'!$D86,2)=0,LEFT('Card List'!$D86,2),'Card List'!$D86)","v":0.05}]
[{"$f":"IF(+'Card List'!$A34=\"\",\"\",+'Card List'!$A34)","v":0},{"$f":"+'Card List'!$B34","v":"Hardee's"},{"$f":"+'Card List'!$C34","v":10},{"$f":"'Card List'!$D34","v":0.05},null,null,{"$f":"+'Card List'!$A87","v":1},{"$f":"+'Card List'!$B87","v":"Walmart"},{"$f":"+'Card List'!$C87","v":25},{"$f":"+IF(RIGHT('Card List'!$D87,2)=0,LEFT('Card List'!$D87,2),'Card List'!$D87)","v":2.5000000000000001E-2}]
[{"$f":"IF(+'Card List'!$A35=\"\",\"\",+'Card List'!$A35)","v":1},{"$f":"+'Card List'!$B35","v":"Home Depot"},{"$f":"+'Card List'!$C35","v":25},{"$f":"'Card List'!$D35","v":0.04},null,null,{"$f":"+'Card List'!$A88","v":1},{"$f":"+'Card List'!$B88","v":"Walmart"},{"$f":"+'Card List'!$C88","v":100},{"$f":"+IF(RIGHT('Card List'!$D88,2)=0,LEFT('Card List'!$D88,2),'Card List'!$D88)","v":2.5000000000000001E-2}]
[{"$f":"IF(+'Card List'!$A36=\"\",\"\",+'Card List'!$A36)","v":0},{"$f":"+'Card List'!$B36","v":"Jo-Ann Fabric"},{"$f":"+'Card List'!$C36","v":25},{"$f":"'Card List'!$D36","v":0.06},null,null,{"$f":"+'Card List'!$A89","v":0},{"$f":"+'Card List'!$B89","v":"Wendy's"},{"$f":"+'Card List'!$C89","v":10},{"$f":"+IF(RIGHT('Card List'!$D89,2)=0,LEFT('Card List'!$D89,2),'Card List'!$D89)","v":0.04}]
[{"$f":"IF(+'Card List'!$A37=\"\",\"\",+'Card List'!$A37)","v":0},{"$f":"+'Card List'!$B37","v":"Journeys"},{"$f":"+'Card List'!$C37","v":25},{"$f":"'Card List'!$D37","v":0.1},null,null,{"$f":"+'Card List'!$A90","v":0},{"$f":"+'Card List'!$B90","v":0},{"$f":"+'Card List'!$C90","v":0},{"$f":"+IF(RIGHT('Card List'!$D90,2)=0,LEFT('Card List'!$D90,2),'Card List'!$D90)","v":0}]
[{"$f":"IF(+'Card List'!$A38=\"\",\"\",+'Card List'!$A38)","v":0},{"$f":"+'Card List'!$B38","v":"Instacart"},{"$f":"+'Card List'!$C38","v":25},{"$f":"'Card List'!$D38","v":0.05},null,null,{"$f":"+'Card List'!$A91","v":0},{"$f":"+'Card List'!$B91","v":0},{"$f":"+'Card List'!$C91","v":0},{"$f":"+IF(RIGHT('Card List'!$D91,2)=0,LEFT('Card List'!$D91,2),'Card List'!$D91)","v":0}]
[{"$f":"IF(+'Card List'!$A39=\"\",\"\",+'Card List'!$A39)","v":1},{"$f":"+'Card List'!$B39","v":"Kohl's"},{"$f":"+'Card List'!$C39","v":25},{"$f":"'Card List'!$D39","v":0.04},null,null,{"$f":"+'Card List'!$A92","v":0},{"$f":"+'Card List'!$B92","v":0},{"$f":"+'Card List'!$C92","v":0},{"$f":"+IF(RIGHT('Card List'!$D92,2)=0,LEFT('Card List'!$D92,2),'Card List'!$D92)","v":0}]
[{"$f":"IF(+'Card List'!$A40=\"\",\"\",+'Card List'!$A40)","v":1},{"$f":"+'Card List'!$B40","v":"Kohl's"},{"$f":"+'Card List'!$C40","v":100},{"$f":"'Card List'!$D40","v":0.04},null,null,0,"Need to Order"]
[{"$f":"IF(+'Card List'!$A41=\"\",\"\",+'Card List'!$A41)","v":1},{"$f":"+'Card List'!$B41","v":"Kwik Trip"},{"$f":"+'Card List'!$C41","v":25},{"$f":"'Card List'!$D41","v":0.04},null,null,1,"In Stock (on hand)"]
[{"$f":"IF(+'Card List'!$A42=\"\",\"\",+'Card List'!$A42)","v":1},{"$f":"+'Card List'!$B42","v":"Kwik Trip"},{"$f":"+'Card List'!$C42","v":50},{"$f":"'Card List'!$D42","v":0.04}]
[{"$f":"IF(+'Card List'!$A43=\"\",\"\",+'Card List'!$A43)","v":1},{"$f":"+'Card List'!$B43","v":"Kwik Trip"},{"$f":"+'Card List'!$C43","v":100},{"$f":"'Card List'!$D43","v":0.04},null,null,"Other Vendors",null,"Card Amt.","Profit %","Quantity","Cost"]
[{"$f":"IF(+'Card List'!$A44=\"\",\"\",+'Card List'!$A44)","v":0},{"$f":"+'Card List'!$B44","v":"Lowe's"},{"$f":"+'Card List'!$C44","v":25},{"$f":"'Card List'!$D44","v":0.04}]
[{"$f":"IF(+'Card List'!$A45=\"\",\"\",+'Card List'!$A45)","v":1},{"$f":"+'Card List'!$B45","v":"Marcus Theatres"},{"$f":"+'Card List'!$C45","v":25},{"$f":"'Card List'!$D45","v":0.09}]
[{"$f":"IF(+'Card List'!$A46=\"\",\"\",+'Card List'!$A46)","v":1},{"$f":"+'Card List'!$B46","v":"Marshalls/TJ Maxx"},{"$f":"+'Card List'!$C46","v":25},{"$f":"'Card List'!$D46","v":7.0000000000000007E-2}]
[{"$f":"IF(+'Card List'!$A47=\"\",\"\",+'Card List'!$A47)","v":0},{"$f":"+'Card List'!$B47","v":"Maurices"},{"$f":"+'Card List'!$C47","v":20},{"$f":"'Card List'!$D47","v":7.0000000000000007E-2}]
[{"$f":"IF(+'Card List'!$A48=\"\",\"\",+'Card List'!$A48)","v":1},{"$f":"+'Card List'!$B48","v":"McDonald's"},{"$f":"+'Card List'!$C48","v":10},{"$f":"'Card List'!$D48","v":0.02}]
[{"$f":"IF(+'Card List'!$A49=\"\",\"\",+'Card List'!$A49)","v":1},{"$f":"+'Card List'!$B49","v":"McDonald's"},{"$f":"+'Card List'!$C49","v":25},{"$f":"'Card List'!$D49","v":0.02}]
[{"$f":"IF(+'Card List'!$A50=\"\",\"\",+'Card List'!$A50)","v":0},{"$f":"+'Card List'!$B50","v":"Meijer"},{"$f":"+'Card List'!$C50","v":25},{"$f":"'Card List'!$D50","v":0.03}]
[{"$f":"IF(+'Card List'!$A51=\"\",\"\",+'Card List'!$A51)","v":0},{"$f":"+'Card List'!$B51","v":"Meijer"},{"$f":"+'Card List'!$C51","v":50},{"$f":"'Card List'!$D51","v":0.03}]
[{"$f":"IF(+'Card List'!$A52=\"\",\"\",+'Card List'!$A52)","v":1},{"$f":"+'Card List'!$B52","v":"Menards"},{"$f":"+'Card List'!$C52","v":25},{"$f":"'Card List'!$D52","v":0.03}]
[{"$f":"IF(+'Card List'!$A53=\"\",\"\",+'Card List'!$A53)","v":0},{"$f":"+'Card List'!$B53","v":"Michael's"},{"$f":"+'Card List'!$C53","v":25},{"$f":"'Card List'!$D53","v":0.04}]
[{"$f":"IF(+'Card List'!$A54=\"\",\"\",+'Card List'!$A54)","v":1},{"$f":"+'Card List'!$B54","v":"Noodles & Co"},{"$f":"+'Card List'!$C54","v":10},{"$f":"'Card List'!$D54","v":0.08},null,null,"Total Individual Order:"]
[{"$f":"+'Card List'!$A55","v":0},{"$f":"+'Card List'!$B55","v":"Old Navy"},{"$f":"+'Card List'!$C55","v":25},{"$f":"+IF(RIGHT('Card List'!$D55,2)=0,LEFT('Card List'!$D55,2),'Card List'!$D55)","v":0.14000000000000001}]
[null,null,null,null,null,null,"Amount Individual Paid:"]

{"sheet":"Monthly Sales","index":3,"n_rows":117,"n_cols":14,"rows_kept":117,"cut":false,"hidden":false,"merged":[[101,0,101,1],[0,0,1,13],[68,0,68,2],[76,0,77,0],[76,1,77,1],[2,12,2,13],[2,10,2,11],[65,0,65,1],[55,0,55,1],[63,0,63,1],[2,1,3,1],[2,0,3,0],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[76,2,76,3],[76,4,76,5],[76,6,76,7],[76,8,76,9],[76,10,76,11],[104,10,104,11],[103,0,103,6],[104,0,105,0],[104,1,105,1],[104,2,104,3],[104,4,104,5],[104,6,104,7],[70,11,70,12],[115,12,115,13],[116,12,116,13],[109,12,109,13],[110,12,110,13],[111,12,111,13],[112,12,112,13],[113,12,113,13],[104,12,105,13],[106,12,106,13],[107,12,107,13],[108,12,108,13],[114,12,114,13],[76,12,76,13],[72,0,73,13],[104,8,104,9],[70,0,70,2],[70,3,70,4],[70,5,70,6],[70,7,70,8],[70,9,70,10],[67,11,67,12],[68,5,68,6],[69,5,69,6],[68,7,68,8],[69,7,69,8],[68,9,68,10],[69,9,69,10],[68,11,68,12],[69,11,69,12],[67,9,67,10],[68,3,68,4],[69,3,69,4],[67,3,67,4],[67,5,67,6],[67,7,67,8]]}
["LCR Scrip Sales for the Month and Year of:   ________________________"]
[]
["Retailer\n(Cards in Stock)","Card Amount","Date:    ",null,"Date:    ",null,"Date:    ",null,"Date:    ",null,"Date:    ",null,"Total Month Sales"]
[null,null,"# Cards","$","# Cards","$","# Cards","$","# Cards","$","# Cards","$","# Cards","$"]
[{"$f":"+'Individual Order Form'!B2","v":"Amazon"},{"$f":"+'Individual Order Form'!C2","v":25},null,{"$f":"IF(C5=\"\",0,+$B5*C5)","v":0},null,{"$f":"IF(E5=\"\",0,+$B5*E5)","v":0},null,{"$f":"IF(G5=\"\",0,+$B5*G5)","v":0},null,{"$f":"IF(I5=\"\",0,+$B5*I5)","v":0},null,{"$f":"IF(K5=\"\",0,+$B5*K5)","v":0},{"$f":"+C5+E5+G5+I5+K5","v":0},{"$f":"+D5+F5+H5+J5+L5","v":0}]
[{"$f":"+'Individual Order Form'!B5","v":"Apple iTunes"},{"$f":"+'Individual Order Form'!C5","v":15},null,{"$f":"IF(C6=\"\",0,+$B6*C6)","v":0},null,{"$f":"IF(E6=\"\",0,+$B6*E6)","v":0},null,{"$f":"IF(G6=\"\",0,+$B6*G6)","v":0},null,{"$f":"IF(I6=\"\",0,+$B6*I6)","v":0},null,{"$f":"IF(K6=\"\",0,+$B6*K6)","v":0},{"$f":"+C6+E6+G6+I6+K6","v":0},{"$f":"+D6+F6+H6+J6+L6","v":0}]
[{"$f":"+'Individual Order Form'!B6","v":"Applebee's"},{"$f":"+'Individual Order Form'!C6","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B7","v":"Arby's"},{"$f":"+'Individual Order Form'!C7","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B8","v":"Barnes & Noble"},{"$f":"+'Individual Order Form'!C8","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B11","v":"Best Buy"},{"$f":"+'Individual Order Form'!C11","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B12","v":"BP Oil/Amoco"},{"$f":"+'Individual Order Form'!C12","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B14","v":"Burger King"},{"$f":"+'Individual Order Form'!C14","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B15","v":"Cheddars"},{"$f":"+'Individual Order Form'!C15","v":25},null,0,null,0,null,0,null,0,null,0,{"$f":"+C13+E13+G13+I13+K13","v":0},{"$f":"+D13+F13+H13+J13+L13","v":0}]
[{"$f":"+'Individual Order Form'!B18","v":"Chipotle"},{"$f":"+'Individual Order Form'!C18","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B19","v":"Cousin's"},{"$f":"+'Individual Order Form'!C19","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B20","v":"Cracker Barrel"},{"$f":"+'Individual Order Form'!C20","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B25","v":"Dunkin' "},{"$f":"+'Individual Order Form'!C25","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B26","v":"Exxon/Mobil"},{"$f":"+'Individual Order Form'!C26","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B27","v":"Festival Foods"},{"$f":"+'Individual Order Form'!C27","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B28","v":"Festival Foods"},{"$f":"+'Individual Order Form'!C28","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B35","v":"Home Depot"},{"$f":"+'Individual Order Form'!C35","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B38","v":"Instacart"},{"$f":"+'Individual Order Form'!C38","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B39","v":"Kohl's"},{"$f":"+'Individual Order Form'!C39","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B40","v":"Kohl's"},{"$f":"+'Individual Order Form'!C40","v":100},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B41","v":"Kwik Trip"},{"$f":"+'Individual Order Form'!C41","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B42","v":"Kwik Trip"},{"$f":"+'Individual Order Form'!C42","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B44","v":"Lowe's"},{"$f":"+'Individual Order Form'!C44","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B47","v":"Maurices"},{"$f":"+'Individual Order Form'!C47","v":20},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B48","v":"McDonald's"},{"$f":"+'Individual Order Form'!C48","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B51","v":"Meijer"},{"$f":"+'Individual Order Form'!C51","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B53","v":"Michael's"},{"$f":"+'Individual Order Form'!C53","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!B55","v":"Old Navy"},{"$f":"+'Individual Order Form'!C55","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H2","v":"Old Navy"},{"$f":"+'Individual Order Form'!I2","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H3","v":"Olive Garden"},{"$f":"+'Individual Order Form'!I3","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H4","v":"Panda Express"},{"$f":"+'Individual Order Form'!I4","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H7","v":"Papa John's"},{"$f":"+'Individual Order Form'!I7","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H8","v":"Papa Murphy's"},{"$f":"+'Individual Order Form'!I8","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H9","v":"Piggly Wiggly"},{"$f":"+'Individual Order Form'!I9","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H15","v":"Red Lobster"},{"$f":"+'Individual Order Form'!I15","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H16","v":"Red Robin"},{"$f":"+'Individual Order Form'!I16","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H17","v":"Roundy's"},{"$f":"+'Individual Order Form'!I17","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H19","v":"Roundy's"},{"$f":"+'Individual Order Form'!I19","v":100},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H20","v":"Shell "},{"$f":"+'Individual Order Form'!I20","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H21","v":"Speedway"},{"$f":"+'Individual Order Form'!I21","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H22","v":"Speedway"},{"$f":"+'Individual Order Form'!I22","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H23","v":"Speedway"},{"$f":"+'Individual Order Form'!I23","v":100},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H24","v":"Starbucks"},{"$f":"+'Individual Order Form'!I24","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H25","v":"Starbucks"},{"$f":"+'Individual Order Form'!I25","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H26","v":"Subway"},{"$f":"+'Individual Order Form'!I26","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H27","v":"Taco Bell"},{"$f":"+'Individual Order Form'!I27","v":10},null,0,null,0,null,0,null,0,null,0,{"$f":"+C50+E50+G50+I50+K50","v":0},{"$f":"+D50+F50+H50+J50+L50","v":0}]
[{"$f":"+'Individual Order Form'!H28","v":"Target"},{"$f":"+'Individual Order Form'!I28","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H30","v":"TJ Maxx/Home Goods"},{"$f":"+'Individual Order Form'!I30","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H31","v":"Ulta"},{"$f":"+'Individual Order Form'!I31","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H33","v":"Walgreens"},{"$f":"+'Individual Order Form'!I33","v":100},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Individual Order Form'!H34","v":"Walmart"},{"$f":"+'Individual Order Form'!I34","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
["Total sales of cards in stock",null,{"$f":"+SUM(C5:C55)","v":0},{"$f":"SUM(D5:D55)","v":0},{"$f":"+SUM(E5:E55)","v":0},{"$f":"SUM(F5:F55)","v":0},{"$f":"+SUM(G5:G55)","v":0},{"$f":"SUM(H5:H55)","v":0},{"$f":"+SUM(I5:I55)","v":0},{"$f":"SUM(J5:J55)","v":0},{"$f":"+SUM(K5:K55)","v":0},{"$f":"SUM(L5:L55)","v":0},{"$f":"+SUM(M5:M55)","v":0},{"$f":"SUM(N5:N55)","v":0}]
[]
["Cards needed to be ordered (not in stock):   NOTE if more rows are needed use form on back to list."]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
["Total sales of cards needing to be ordered",null,{"$f":"SUM(C59:C63)+C102","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["TOTAL SALES",null,{"$f":"+C56+C64","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["SUMMARY",null,null,{"$f":"+C3","v":"Date:    "},null,{"$f":"+E3","v":"Date:    "},null,{"$f":"+G3","v":"Date:    "},null,{"$f":"+I3","v":"Date:    "},null,{"$f":"+K3","v":"Date:    "},null,"TOTAL"]
["Total Deposit (Cash/Checks)",null,null,0,null,0,null,0,null,0,null,0,null,0]
["Net IOU's from back page (owed - pd back)",null,null,{"$f":"+C117-D117","v":0},null,{"$f":"+E117-F117","v":0},null,{"$f":"+G117-H117","v":0},null,{"$f":"+I117-J117","v":0},null,{"$f":"+K117-L117","v":0},null,0]
["Check:  all must TIE",null,null,{"$f":"IF(+D66-D69-D70=0,\"TIES\",\"$\"&D66-D69-D70&\" ERROR\")","v":"TIES"},null,{"$f":"IF(+F66-F69-F70=0,\"TIES\",\"$\"&F66-F69-F70&\" ERROR\")","v":"TIES"},null,{"$f":"IF(+H66-H69-H70=0,\"TIES\",\"$\"&H66-H69-H70&\" ERROR\")","v":"TIES"},null,{"$f":"IF(+J66-J69-J70=0,\"TIES\",\"$\"&J66-J69-J70&\" ERROR\")","v":"TIES"},null,{"$f":"IF(+L66-L69-L70=0,\"TIES\",\"$\"&L66-L69-L70&\" ERROR\")","v":"TIES"}]
[]
[{"$f":"+A1","v":"LCR Scrip Sales for the Month and Year of:   ________________________"}]
[]
[]
["Cards needed to be ordered (not in stock):   Continued from Front page"]
["Retailer","Card Amount",{"$f":"+C$3","v":"Date:    "},null,{"$f":"+E$3","v":"Date:    "},null,{"$f":"+G$3","v":"Date:    "},null,{"$f":"+I$3","v":"Date:    "},null,{"$f":"+K$3","v":"Date:    "},null,"Total Month Sales"]
[null,null,"# Cards","$","# Cards","$","# Cards","$","# Cards","$","# Cards","$","# Cards","$"]
[null,null,null,{"$f":"IF(C79=\"\",0,+$B79*C79)","v":0},null,{"$f":"IF(E79=\"\",0,+$B79*E79)","v":0},null,{"$f":"IF(G79=\"\",0,+$B79*G79)","v":0},null,{"$f":"IF(I79=\"\",0,+$B79*I79)","v":0},null,{"$f":"IF(K79=\"\",0,+$B79*K79)","v":0},{"$f":"+C79+E79+G79+I79+K79","v":0},{"$f":"+D79+F79+H79+J79+L79","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,{"$f":"+C80+E80+G80+I80+K80","v":0},{"$f":"+D80+F80+H80+J80+L80","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
["Total (included in total on front page)",null,{"$f":"SUM(C79:C101)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["IOU Tracking"]
["Name of IOU Individual","Amt carried forward from last month",{"$f":"+C$3","v":"Date:    "},null,{"$f":"+E$3","v":"Date:    "},null,{"$f":"+G$3","v":"Date:    "},null,{"$f":"+I$3","v":"Date:    "},null,{"$f":"+K$3","v":"Date:    "},null,"Total Still Owed \n(carry forward to next month)"]
[null,null,"$ owed","$ paid back","$ owed","$ paid back","$ owed","$ paid back","$ owed","$ paid back","$ owed","$ paid back"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B107+C107-D107+E107-F107+G107-H107+J107-K107","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B108+C108-D108+E108-F108+G108-H108+J108-K108","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B110+C110-D110+E110-F110+G110-H110+J110-K110","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total IOU's",{"$f":"SUM(B107:B116)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(M107:N116)","v":0}]

{"sheet":"Monthly Orders","index":4,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[55,0,55,1],[64,0,64,1],[66,0,66,1],[0,0,1,13],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13]]}
["LCR Scrip Purchases for the Month and Year of:   ________________________"]
[]
["Retailer\n(Cards on hand)","Card Amount","Date:    ",null,"Date:    ",null,"Date:    ",null,"Date:    ",null,"Date:    ",null,"Total Month Purchases"]
[null,null,"# Cards","$","# Cards","$","# Cards","$","# Cards","$","# Cards","$","# Cards","$"]
[{"$f":"+'Monthly Sales'!A5","v":"Amazon"},{"$f":"+'Monthly Sales'!B5","v":25},null,{"$f":"IF(C5=\"\",0,+$B5*C5)","v":0},null,{"$f":"IF(E5=\"\",0,+$B5*E5)","v":0},null,{"$f":"IF(G5=\"\",0,+$B5*G5)","v":0},null,{"$f":"IF(I5=\"\",0,+$B5*I5)","v":0},null,{"$f":"IF(K5=\"\",0,+$B5*K5)","v":0},{"$f":"+C5+E5+G5+I5+K5","v":0},{"$f":"+D5+F5+H5+J5+L5","v":0}]
[{"$f":"+'Monthly Sales'!A6","v":"Apple iTunes"},{"$f":"+'Monthly Sales'!B6","v":15},null,{"$f":"IF(C6=\"\",0,+$B6*C6)","v":0},null,{"$f":"IF(E6=\"\",0,+$B6*E6)","v":0},null,{"$f":"IF(G6=\"\",0,+$B6*G6)","v":0},null,{"$f":"IF(I6=\"\",0,+$B6*I6)","v":0},null,{"$f":"IF(K6=\"\",0,+$B6*K6)","v":0},{"$f":"+C6+E6+G6+I6+K6","v":0},0]
[{"$f":"+'Monthly Sales'!A7","v":"Applebee's"},{"$f":"+'Monthly Sales'!B7","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A8","v":"Arby's"},{"$f":"+'Monthly Sales'!B8","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A9","v":"Barnes & Noble"},{"$f":"+'Monthly Sales'!B9","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A10","v":"Best Buy"},{"$f":"+'Monthly Sales'!B10","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A11","v":"BP Oil/Amoco"},{"$f":"+'Monthly Sales'!B11","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A12","v":"Burger King"},{"$f":"+'Monthly Sales'!B12","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A13","v":"Cheddars"},{"$f":"+'Monthly Sales'!B13","v":25},null,0,null,0,null,0,null,0,null,0,{"$f":"+C13+E13+G13+I13+K13","v":0},{"$f":"+D13+F13+H13+J13+L13","v":0}]
[{"$f":"+'Monthly Sales'!A14","v":"Chipotle"},{"$f":"+'Monthly Sales'!B14","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A15","v":"Cousin's"},{"$f":"+'Monthly Sales'!B15","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A16","v":"Cracker Barrel"},{"$f":"+'Monthly Sales'!B16","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A17","v":"Dunkin' "},{"$f":"+'Monthly Sales'!B17","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A18","v":"Exxon/Mobil"},{"$f":"+'Monthly Sales'!B18","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A19","v":"Festival Foods"},{"$f":"+'Monthly Sales'!B19","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A20","v":"Festival Foods"},{"$f":"+'Monthly Sales'!B20","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A21","v":"Home Depot"},{"$f":"+'Monthly Sales'!B21","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A22","v":"Instacart"},{"$f":"+'Monthly Sales'!B22","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A23","v":"Kohl's"},{"$f":"+'Monthly Sales'!B23","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A24","v":"Kohl's"},{"$f":"+'Monthly Sales'!B24","v":100},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A25","v":"Kwik Trip"},{"$f":"+'Monthly Sales'!B25","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A26","v":"Kwik Trip"},{"$f":"+'Monthly Sales'!B26","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A27","v":"Lowe's"},{"$f":"+'Monthly Sales'!B27","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A28","v":"Maurices"},{"$f":"+'Monthly Sales'!B28","v":20},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A29","v":"McDonald's"},{"$f":"+'Monthly Sales'!B29","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A30","v":"Meijer"},{"$f":"+'Monthly Sales'!B30","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A31","v":"Michael's"},{"$f":"+'Monthly Sales'!B31","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A32","v":"Old Navy"},{"$f":"+'Monthly Sales'!B32","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A33","v":"Old Navy"},{"$f":"+'Monthly Sales'!B33","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A34","v":"Olive Garden"},{"$f":"+'Monthly Sales'!B34","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A35","v":"Panda Express"},{"$f":"+'Monthly Sales'!B35","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A36","v":"Papa John's"},{"$f":"+'Monthly Sales'!B36","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A37","v":"Papa Murphy's"},{"$f":"+'Monthly Sales'!B37","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A38","v":"Piggly Wiggly"},{"$f":"+'Monthly Sales'!B38","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A39","v":"Red Lobster"},{"$f":"+'Monthly Sales'!B39","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A40","v":"Red Robin"},{"$f":"+'Monthly Sales'!B40","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A41","v":"Roundy's"},{"$f":"+'Monthly Sales'!B41","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A42","v":"Roundy's"},{"$f":"+'Monthly Sales'!B42","v":100},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A43","v":"Shell "},{"$f":"+'Monthly Sales'!B43","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A44","v":"Speedway"},{"$f":"+'Monthly Sales'!B44","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A45","v":"Speedway"},{"$f":"+'Monthly Sales'!B45","v":50},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A46","v":"Speedway"},{"$f":"+'Monthly Sales'!B46","v":100},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A47","v":"Starbucks"},{"$f":"+'Monthly Sales'!B47","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A48","v":"Starbucks"},{"$f":"+'Monthly Sales'!B48","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A49","v":"Subway"},{"$f":"+'Monthly Sales'!B49","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A50","v":"Taco Bell"},{"$f":"+'Monthly Sales'!B50","v":10},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A51","v":"Target"},{"$f":"+'Monthly Sales'!B51","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A52","v":"TJ Maxx/Home Goods"},{"$f":"+'Monthly Sales'!B52","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A53","v":"Ulta"},{"$f":"+'Monthly Sales'!B53","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A54","v":"Walgreens"},{"$f":"+'Monthly Sales'!B54","v":100},null,0,null,0,null,0,null,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A55","v":"Walmart"},{"$f":"+'Monthly Sales'!B55","v":25},null,0,null,0,null,0,null,0,null,0,0,0]
["Total Purchases of Cards kept on hand",null,{"$f":"+SUM(C5:C55)","v":0},{"$f":"SUM(D5:D55)","v":0},{"$f":"+SUM(E5:E55)","v":0},{"$f":"SUM(F5:F55)","v":0},{"$f":"+SUM(G5:G55)","v":0},{"$f":"SUM(H5:H55)","v":0},{"$f":"+SUM(I5:I55)","v":0},{"$f":"SUM(J5:J55)","v":0},{"$f":"+SUM(K5:K55)","v":0},{"$f":"SUM(L5:L55)","v":0},{"$f":"+SUM(M5:M55)","v":0},{"$f":"SUM(N5:N55)","v":0}]
[]
["Cards Ordered (not kept on hand):"]
[null,null,null,0,null,0,null,0,null,0,null,0,{"$f":"+C59+E59+G59+I59+K59","v":0},{"$f":"+D59+F59+H59+J59+L59","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,0,0]
["Total Cards Ordered (not kept on hand)",null,{"$f":"SUM(C59:C64)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Order",null,{"$f":"+C56+C65","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Net Cost",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+D68+F68+H68+J68+L68","v":0}]
["Shipping/handling charge",null,null,0,null,0,null,0,null,0,null,0,null,0]
["Total Order Cost",null,null,{"$f":"+D68+D69","v":0},null,{"$f":"+F68+F69","v":0},null,{"$f":"+H68+H69","v":0},null,{"$f":"+J68+J69","v":0},null,{"$f":"+L68+L69","v":0},null,{"$f":"+N68+N69","v":0}]

{"sheet":"Monthly Inventory","index":5,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[55,0,55,1],[64,0,64,1],[66,0,66,1],[0,0,1,13],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13]]}
["LCR Scrip Purchases for the Month and Year of:   ________________________"]
[]
["Retailer\n(Cards on hand)","Card Amount","Beginning of Month Inventory",null,"Monthly Sales (of cards kep on hand)",null,"Monthly Orders (of cards kept on hand)",null,"Ending of Month Inventory",null,"Count Validation",null,"Differences"]
[null,null,"# Cards","$","# Cards","$","# Cards","$","# Cards","$","# Cards","$","# Cards","$"]
[{"$f":"+'Monthly Sales'!A5","v":"Amazon"},{"$f":"+'Monthly Sales'!B5","v":25},null,{"$f":"IF(C5=\"\",0,+$B5*C5)","v":0},{"$f":"+'Monthly Sales'!M5","v":0},{"$f":"IF(E5=\"\",0,+$B5*E5)","v":0},{"$f":"+'Monthly Orders'!M5","v":0},{"$f":"IF(G5=\"\",0,+$B5*G5)","v":0},{"$f":"+C5-E5+G5","v":0},{"$f":"IF(I5=\"\",0,+$B5*I5)","v":0},null,{"$f":"IF(K5=\"\",0,+$B5*K5)","v":0},{"$f":"+I5-K5","v":0},{"$f":"+J5-L5","v":0}]
[{"$f":"+'Monthly Sales'!A6","v":"Apple iTunes"},{"$f":"+'Monthly Sales'!B6","v":15},null,{"$f":"IF(C6=\"\",0,+$B6*C6)","v":0},{"$f":"+'Monthly Sales'!M6","v":0},{"$f":"IF(E6=\"\",0,+$B6*E6)","v":0},{"$f":"+'Monthly Orders'!M6","v":0},{"$f":"IF(G6=\"\",0,+$B6*G6)","v":0},{"$f":"+C6-E6+G6","v":0},{"$f":"IF(I6=\"\",0,+$B6*I6)","v":0},null,{"$f":"IF(K6=\"\",0,+$B6*K6)","v":0},{"$f":"+I6-K6","v":0},{"$f":"+J6-L6","v":0}]
[{"$f":"+'Monthly Sales'!A7","v":"Applebee's"},{"$f":"+'Monthly Sales'!B7","v":25},null,0,{"$f":"+'Monthly Sales'!M7","v":0},0,{"$f":"+'Monthly Orders'!M7","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A8","v":"Arby's"},{"$f":"+'Monthly Sales'!B8","v":10},null,0,{"$f":"+'Monthly Sales'!M8","v":0},0,{"$f":"+'Monthly Orders'!M8","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A9","v":"Barnes & Noble"},{"$f":"+'Monthly Sales'!B9","v":10},null,0,{"$f":"+'Monthly Sales'!M9","v":0},0,{"$f":"+'Monthly Orders'!M9","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A10","v":"Best Buy"},{"$f":"+'Monthly Sales'!B10","v":25},null,0,{"$f":"+'Monthly Sales'!M10","v":0},0,{"$f":"+'Monthly Orders'!M10","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A11","v":"BP Oil/Amoco"},{"$f":"+'Monthly Sales'!B11","v":50},null,0,{"$f":"+'Monthly Sales'!M11","v":0},0,{"$f":"+'Monthly Orders'!M11","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A12","v":"Burger King"},{"$f":"+'Monthly Sales'!B12","v":10},null,0,{"$f":"+'Monthly Sales'!M12","v":0},0,{"$f":"+'Monthly Orders'!M12","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A13","v":"Cheddars"},{"$f":"+'Monthly Sales'!B13","v":25},null,0,{"$f":"+'Monthly Sales'!M13","v":0},0,{"$f":"+'Monthly Orders'!M13","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A14","v":"Chipotle"},{"$f":"+'Monthly Sales'!B14","v":10},null,0,{"$f":"+'Monthly Sales'!M14","v":0},0,{"$f":"+'Monthly Orders'!M14","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A15","v":"Cousin's"},{"$f":"+'Monthly Sales'!B15","v":10},null,0,{"$f":"+'Monthly Sales'!M15","v":0},0,{"$f":"+'Monthly Orders'!M15","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A16","v":"Cracker Barrel"},{"$f":"+'Monthly Sales'!B16","v":25},null,0,{"$f":"+'Monthly Sales'!M16","v":0},0,{"$f":"+'Monthly Orders'!M16","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A17","v":"Dunkin' "},{"$f":"+'Monthly Sales'!B17","v":10},null,0,{"$f":"+'Monthly Sales'!M17","v":0},0,{"$f":"+'Monthly Orders'!M17","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A18","v":"Exxon/Mobil"},{"$f":"+'Monthly Sales'!B18","v":50},null,0,{"$f":"+'Monthly Sales'!M18","v":0},0,{"$f":"+'Monthly Orders'!M18","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A19","v":"Festival Foods"},{"$f":"+'Monthly Sales'!B19","v":25},null,0,{"$f":"+'Monthly Sales'!M19","v":0},0,{"$f":"+'Monthly Orders'!M19","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A20","v":"Festival Foods"},{"$f":"+'Monthly Sales'!B20","v":50},null,0,{"$f":"+'Monthly Sales'!M20","v":0},0,{"$f":"+'Monthly Orders'!M20","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A21","v":"Home Depot"},{"$f":"+'Monthly Sales'!B21","v":25},null,0,{"$f":"+'Monthly Sales'!M21","v":0},0,{"$f":"+'Monthly Orders'!M21","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A22","v":"Instacart"},{"$f":"+'Monthly Sales'!B22","v":25},null,0,{"$f":"+'Monthly Sales'!M22","v":0},0,{"$f":"+'Monthly Orders'!M22","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A23","v":"Kohl's"},{"$f":"+'Monthly Sales'!B23","v":25},null,0,{"$f":"+'Monthly Sales'!M23","v":0},0,{"$f":"+'Monthly Orders'!M23","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A24","v":"Kohl's"},{"$f":"+'Monthly Sales'!B24","v":100},null,0,{"$f":"+'Monthly Sales'!M24","v":0},0,{"$f":"+'Monthly Orders'!M24","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A25","v":"Kwik Trip"},{"$f":"+'Monthly Sales'!B25","v":25},null,0,{"$f":"+'Monthly Sales'!M25","v":0},0,{"$f":"+'Monthly Orders'!M25","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A26","v":"Kwik Trip"},{"$f":"+'Monthly Sales'!B26","v":50},null,0,{"$f":"+'Monthly Sales'!M26","v":0},0,{"$f":"+'Monthly Orders'!M26","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A27","v":"Lowe's"},{"$f":"+'Monthly Sales'!B27","v":25},null,0,{"$f":"+'Monthly Sales'!M27","v":0},0,{"$f":"+'Monthly Orders'!M27","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A28","v":"Maurices"},{"$f":"+'Monthly Sales'!B28","v":20},null,0,{"$f":"+'Monthly Sales'!M28","v":0},0,{"$f":"+'Monthly Orders'!M28","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A29","v":"McDonald's"},{"$f":"+'Monthly Sales'!B29","v":10},null,0,{"$f":"+'Monthly Sales'!M29","v":0},0,{"$f":"+'Monthly Orders'!M29","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A30","v":"Meijer"},{"$f":"+'Monthly Sales'!B30","v":50},null,0,{"$f":"+'Monthly Sales'!M30","v":0},0,{"$f":"+'Monthly Orders'!M30","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A31","v":"Michael's"},{"$f":"+'Monthly Sales'!B31","v":25},null,0,{"$f":"+'Monthly Sales'!M31","v":0},0,{"$f":"+'Monthly Orders'!M31","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A32","v":"Old Navy"},{"$f":"+'Monthly Sales'!B32","v":25},null,0,{"$f":"+'Monthly Sales'!M32","v":0},0,{"$f":"+'Monthly Orders'!M32","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A33","v":"Old Navy"},{"$f":"+'Monthly Sales'!B33","v":25},null,0,{"$f":"+'Monthly Sales'!M33","v":0},0,{"$f":"+'Monthly Orders'!M33","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A34","v":"Olive Garden"},{"$f":"+'Monthly Sales'!B34","v":25},null,0,{"$f":"+'Monthly Sales'!M34","v":0},0,{"$f":"+'Monthly Orders'!M34","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A35","v":"Panda Express"},{"$f":"+'Monthly Sales'!B35","v":25},null,0,{"$f":"+'Monthly Sales'!M35","v":0},0,{"$f":"+'Monthly Orders'!M35","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A36","v":"Papa John's"},{"$f":"+'Monthly Sales'!B36","v":10},null,0,{"$f":"+'Monthly Sales'!M36","v":0},0,{"$f":"+'Monthly Orders'!M36","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A37","v":"Papa Murphy's"},{"$f":"+'Monthly Sales'!B37","v":10},null,0,{"$f":"+'Monthly Sales'!M37","v":0},0,{"$f":"+'Monthly Orders'!M37","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A38","v":"Piggly Wiggly"},{"$f":"+'Monthly Sales'!B38","v":25},null,0,{"$f":"+'Monthly Sales'!M38","v":0},0,{"$f":"+'Monthly Orders'!M38","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A39","v":"Red Lobster"},{"$f":"+'Monthly Sales'!B39","v":25},null,0,{"$f":"+'Monthly Sales'!M39","v":0},0,{"$f":"+'Monthly Orders'!M39","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A40","v":"Red Robin"},{"$f":"+'Monthly Sales'!B40","v":25},null,0,{"$f":"+'Monthly Sales'!M40","v":0},0,{"$f":"+'Monthly Orders'!M40","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A41","v":"Roundy's"},{"$f":"+'Monthly Sales'!B41","v":25},null,0,{"$f":"+'Monthly Sales'!M41","v":0},0,{"$f":"+'Monthly Orders'!M41","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A42","v":"Roundy's"},{"$f":"+'Monthly Sales'!B42","v":100},null,0,{"$f":"+'Monthly Sales'!M42","v":0},0,{"$f":"+'Monthly Orders'!M42","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A43","v":"Shell "},{"$f":"+'Monthly Sales'!B43","v":25},null,0,{"$f":"+'Monthly Sales'!M43","v":0},0,{"$f":"+'Monthly Orders'!M43","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A44","v":"Speedway"},{"$f":"+'Monthly Sales'!B44","v":25},null,0,{"$f":"+'Monthly Sales'!M44","v":0},0,{"$f":"+'Monthly Orders'!M44","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A45","v":"Speedway"},{"$f":"+'Monthly Sales'!B45","v":50},null,0,{"$f":"+'Monthly Sales'!M45","v":0},0,{"$f":"+'Monthly Orders'!M45","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A46","v":"Speedway"},{"$f":"+'Monthly Sales'!B46","v":100},null,0,{"$f":"+'Monthly Sales'!M46","v":0},0,{"$f":"+'Monthly Orders'!M46","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A47","v":"Starbucks"},{"$f":"+'Monthly Sales'!B47","v":10},null,0,{"$f":"+'Monthly Sales'!M47","v":0},0,{"$f":"+'Monthly Orders'!M47","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A48","v":"Starbucks"},{"$f":"+'Monthly Sales'!B48","v":25},null,0,{"$f":"+'Monthly Sales'!M48","v":0},0,{"$f":"+'Monthly Orders'!M48","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A49","v":"Subway"},{"$f":"+'Monthly Sales'!B49","v":10},null,0,{"$f":"+'Monthly Sales'!M49","v":0},0,{"$f":"+'Monthly Orders'!M49","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A50","v":"Taco Bell"},{"$f":"+'Monthly Sales'!B50","v":10},null,0,{"$f":"+'Monthly Sales'!M50","v":0},0,{"$f":"+'Monthly Orders'!M50","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A51","v":"Target"},{"$f":"+'Monthly Sales'!B51","v":25},null,0,{"$f":"+'Monthly Sales'!M51","v":0},0,{"$f":"+'Monthly Orders'!M51","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A52","v":"TJ Maxx/Home Goods"},{"$f":"+'Monthly Sales'!B52","v":25},null,0,{"$f":"+'Monthly Sales'!M52","v":0},0,{"$f":"+'Monthly Orders'!M52","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A53","v":"Ulta"},{"$f":"+'Monthly Sales'!B53","v":25},null,0,{"$f":"+'Monthly Sales'!M53","v":0},0,{"$f":"+'Monthly Orders'!M53","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A54","v":"Walgreens"},{"$f":"+'Monthly Sales'!B54","v":100},null,0,{"$f":"+'Monthly Sales'!M54","v":0},0,{"$f":"+'Monthly Orders'!M54","v":0},0,0,0,null,0,0,0]
[{"$f":"+'Monthly Sales'!A55","v":"Walmart"},{"$f":"+'Monthly Sales'!B55","v":25},null,0,{"$f":"+'Monthly Sales'!M55","v":0},0,{"$f":"+'Monthly Orders'!M55","v":0},0,0,0,null,0,0,0]
["Total",null,{"$f":"+SUM(C5:C55)","v":0},{"$f":"SUM(D5:D55)","v":0},{"$f":"+SUM(E5:E55)","v":0},{"$f":"SUM(F5:F55)","v":0},{"$f":"+SUM(G5:G55)","v":0},{"$f":"SUM(H5:H55)","v":0},{"$f":"+SUM(I5:I55)","v":0},{"$f":"SUM(J5:J55)","v":0},{"$f":"+SUM(K5:K55)","v":0},{"$f":"SUM(L5:L55)","v":0},{"$f":"+SUM(M5:M55)","v":0},{"$f":"SUM(N5:N55)","v":0}]
[]
["Other cards in inventory, if any?"]
[null,null,null,{"$f":"IF(C59=\"\",0,+$B59*C59)","v":0},null,{"$f":"IF(E59=\"\",0,+$B59*E59)","v":0},null,{"$f":"IF(G59=\"\",0,+$B59*G59)","v":0},{"$f":"+C59-E59+G59","v":0},{"$f":"IF(I59=\"\",0,+$B59*I59)","v":0},null,{"$f":"IF(K59=\"\",0,+$B59*K59)","v":0},{"$f":"+I59-K59","v":0},{"$f":"+J59-L59","v":0}]
[null,null,null,0,null,0,null,0,0,0,null,0,0,0]
[null,null,null,0,null,0,null,0,0,0,null,0,0,0]
[null,null,null,0,null,0,null,0,0,0,null,0,0,0]
[null,null,null,0,null,0,null,0,0,0,null,0,0,0]
[null,null,null,0,null,0,null,0,0,0,null,0,0,0]
["Total other cards in inventory",null,{"$f":"SUM(C59:C64)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Inventory",null,{"$f":"+C56+C65","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Formulas","index":6,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Individual Order Row formulas"]
[null,{"$f":"IF(+'Card List'!$A2=\"\",\"\",+'Card List'!$A2)","v":1},{"$f":"IF(+'Card List'!$B2=\"\",\"\",+'Card List'!$B2)","v":"Amazon"},{"$f":"IF(+'Card List'!$C2=\"\",\"\",+'Card List'!$C2)","v":25},{"$f":"IF('Card List'!$D2=\"\",\"\",'Card List'!$D2)","v":2.2499999999999999E-2}]
[null,{"$f":"IF(+'Card List'!$A56=\"\",\"\",+'Card List'!$A56)","v":1},{"$f":"IF(+'Card List'!$B56=\"\",\"\",+'Card List'!$B56)","v":"Olive Garden"},{"$f":"+'Card List'!$C56","v":25},{"$f":"'Card List'!$D56","v":0.08}]

{"sheet":"Sheet3","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}